﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MyCodeMasterPage.master" AutoEventWireup="true" CodeFile="ExcelToDB.aspx.cs" Inherits="IO_ExcelToDB" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentCodeDetails" Runat="Server">

    <p style="margin-top: 18px">
        <b>Import Excel(.xls) / CSV(.csv) file to database table</b></p>
    <hr style="background-color: Black; margin-bottom: 15px;" />

    <p style="margin-bottom: 6px">
        1. select a xls file to upload</p>
    <p>
<%--        <rad:RadUpload runat="server" ID="radUp" OnInit="radUp_OnInit" OnValidatingFile="radUp_OnValidatingFile"></rad:RadUpload>        
--%>        
        <asp:FileUpload ID="fupXls" runat="server" />&nbsp;
        <asp:Button ID="btnUpXls" runat="server" Text="Upload" OnClick="btnUpXls_Click" />
        <asp:Label ID="lblMessageXls" runat="server" Text="" Visible="False"
            ForeColor="Red"></asp:Label>
    </p>

    <hr style="background-color: Black; margin-bottom: 15px;" />

    <p style="margin-bottom: 6px">
        2. select a csv file to upload</p>
    <p>
        <asp:FileUpload ID="fupCsv" runat="server" />&nbsp;
        <asp:Button ID="btnUpCsv" runat="server" Text="Upload" OnClick="btnUpCsv_Click" />
        <asp:Label ID="lblMessageCsv" runat="server" Text="" Visible="False"
            ForeColor="Red"></asp:Label>
    </p>

    <asp:GridView ID = "gvUpdata" runat="server" AutoGenerateColumns="true"
            BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
            CellPadding="3">
            <Columns>
            
            </Columns>

        <FooterStyle BackColor="White" ForeColor="#000066" />
        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        <RowStyle ForeColor="#000066" />
        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
    </asp:GridView>


</asp:Content>

